Pandas Profiling Report

Dataset statistics

Number of variables	9
Number of observations	1000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	70.4 KiB
Average record size in memory	72.1 B

Variable types

Numeric	7
Categorical	2

Alerts

`id` is uniformly distributed	Uniform
`id` has unique values	Unique

Reproduction

Analysis started	2024-07-01 10:00:44.315430
Analysis finished	2024-07-01 10:00:58.090652
Duration	13.78 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

id
Real number (ℝ)

UNIFORM UNIQUE

Distinct	1000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	500.5

Minimum	1
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	1
5-th percentile	50.95
Q1	250.75
median	500.5
Q3	750.25
95-th percentile	950.05
Maximum	1000
Range	999
Interquartile range (IQR)	499.5

Descriptive statistics

Standard deviation	288.81944
Coefficient of variation (CV)	0.57706181
Kurtosis	-1.2
Mean	500.5
Median Absolute Deviation (MAD)	250
Skewness	0
Sum	500500
Variance	83416.667
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	0.1%
672	1	0.1%
659	1	0.1%
660	1	0.1%
661	1	0.1%
662	1	0.1%
663	1	0.1%
664	1	0.1%
665	1	0.1%
666	1	0.1%
Other values (990)	990	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	0.1%
2	1	0.1%
3	1	0.1%
4	1	0.1%
5	1	0.1%
6	1	0.1%
7	1	0.1%
8	1	0.1%
9	1	0.1%
10	1	0.1%

Value	Count	Frequency (%)
1000	1	0.1%
999	1	0.1%
998	1	0.1%
997	1	0.1%
996	1	0.1%
995	1	0.1%
994	1	0.1%
993	1	0.1%
992	1	0.1%
991	1	0.1%

age
Real number (ℝ)

Distinct	52
Distinct (%)	5.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	43.783

Minimum	18
Maximum	69
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	18
5-th percentile	20
Q1	30
median	45
Q3	57
95-th percentile	67
Maximum	69
Range	51
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	15.042213
Coefficient of variation (CV)	0.34356287
Kurtosis	-1.1926685
Mean	43.783
Median Absolute Deviation (MAD)	13
Skewness	-0.046000137
Sum	43783
Variance	226.26818
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
47	32	3.2%
30	30	3.0%
33	29	2.9%
45	29	2.9%
53	28	2.8%
19	28	2.8%
69	28	2.8%
64	27	2.7%
41	25	2.5%
61	24	2.4%
Other values (42)	720	72.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18	21	2.1%
19	28	2.8%
20	12	1.2%
21	14	1.4%
22	22	2.2%
23	23	2.3%
24	11	1.1%
25	13	1.3%
26	21	2.1%
27	20	2.0%

Value	Count	Frequency (%)
69	28	2.8%
68	19	1.9%
67	10	1.0%
66	15	1.5%
65	14	1.4%
64	27	2.7%
63	20	2.0%
62	20	2.0%
61	24	2.4%
60	23	2.3%

gender
Categorical

Distinct	3
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

Male	357
Other	327
Female	316

Length

Max length	6
Median length	5
Mean length	4.959
Min length	4

Characters and Unicode

Total characters	4959
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Female
2nd row	Female
3rd row	Female
4th row	Other
5th row	Female

Common Values

Value	Count	Frequency (%)
Male	357	35.7%
Other	327	32.7%
Female	316	31.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
male	357	35.7%
other	327	32.7%
female	316	31.6%

Most occurring characters

Value	Count	Frequency (%)
e	1316	26.5%
a	673	13.6%
l	673	13.6%
M	357	7.2%
O	327	6.6%
t	327	6.6%
h	327	6.6%
r	327	6.6%
F	316	6.4%
m	316	6.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4959	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1316	26.5%
a	673	13.6%
l	673	13.6%
M	357	7.2%
O	327	6.6%
t	327	6.6%
h	327	6.6%
r	327	6.6%
F	316	6.4%
m	316	6.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4959	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1316	26.5%
a	673	13.6%
l	673	13.6%
M	357	7.2%
O	327	6.6%
t	327	6.6%
h	327	6.6%
r	327	6.6%
F	316	6.4%
m	316	6.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4959	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1316	26.5%
a	673	13.6%
l	673	13.6%
M	357	7.2%
O	327	6.6%
t	327	6.6%
h	327	6.6%
r	327	6.6%
F	316	6.4%
m	316	6.4%

income
Real number (ℝ)

Distinct	996
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	88500.8

Minimum	30004
Maximum	149973
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	30004
5-th percentile	36274.9
Q1	57911.75
median	87845.5
Q3	116110.25
95-th percentile	143433.4
Maximum	149973
Range	119969
Interquartile range (IQR)	58198.5

Descriptive statistics

Standard deviation	34230.771
Coefficient of variation (CV)	0.38678488
Kurtosis	-1.1673027
Mean	88500.8
Median Absolute Deviation (MAD)	29250.5
Skewness	0.051064873
Sum	88500800
Variance	1.1717457 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
49020	2	0.2%
39407	2	0.2%
137307	2	0.2%
61376	2	0.2%
54274	1	0.1%
59108	1	0.1%
87717	1	0.1%
48576	1	0.1%
135394	1	0.1%
99342	1	0.1%
Other values (986)	986	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
30004	1	0.1%
30058	1	0.1%
30074	1	0.1%
30102	1	0.1%
30121	1	0.1%
30374	1	0.1%
30492	1	0.1%
30523	1	0.1%
30570	1	0.1%
30708	1	0.1%

Value	Count	Frequency (%)
149973	1	0.1%
149936	1	0.1%
149744	1	0.1%
149741	1	0.1%
149723	1	0.1%
149578	1	0.1%
149505	1	0.1%
149256	1	0.1%
149062	1	0.1%
148784	1	0.1%

spending_score
Real number (ℝ)

Distinct	100
Distinct (%)	10.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	50.685

Minimum	1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	26
median	50
Q3	76
95-th percentile	96
Maximum	100
Range	99
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	28.955175
Coefficient of variation (CV)	0.57127701
Kurtosis	-1.2160064
Mean	50.685
Median Absolute Deviation (MAD)	25
Skewness	-0.016577324
Sum	50685
Variance	838.40218
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
70	20	2.0%
27	19	1.9%
96	17	1.7%
100	17	1.7%
83	16	1.6%
69	16	1.6%
19	15	1.5%
79	15	1.5%
68	15	1.5%
40	15	1.5%
Other values (90)	835	83.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	11	1.1%
2	14	1.4%
3	13	1.3%
4	11	1.1%
5	4	0.4%
6	13	1.3%
7	7	0.7%
8	7	0.7%
9	6	0.6%
10	9	0.9%

Value	Count	Frequency (%)
100	17	1.7%
99	10	1.0%
98	6	0.6%
97	4	0.4%
96	17	1.7%
95	9	0.9%
94	5	0.5%
93	9	0.9%
92	11	1.1%
91	10	1.0%

membership_years
Real number (ℝ)

Distinct	10
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.469

Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	5
Q3	8
95-th percentile	10
Maximum	10
Range	9
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.8557301
Coefficient of variation (CV)	0.52216677
Kurtosis	-1.2065871
Mean	5.469
Median Absolute Deviation (MAD)	2
Skewness	0.02984401
Sum	5469
Variance	8.1551942
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5	125	12.5%
2	109	10.9%
9	108	10.8%
6	96	9.6%
10	96	9.6%
3	95	9.5%
1	95	9.5%
7	94	9.4%
4	94	9.4%
8	88	8.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	95	9.5%
2	109	10.9%
3	95	9.5%
4	94	9.4%
5	125	12.5%
6	96	9.6%
7	94	9.4%
8	88	8.8%
9	108	10.8%
10	96	9.6%

Value	Count	Frequency (%)
10	96	9.6%
9	108	10.8%
8	88	8.8%
7	94	9.4%
6	96	9.6%
5	125	12.5%
4	94	9.4%
3	95	9.5%
2	109	10.9%
1	95	9.5%

purchase_frequency
Real number (ℝ)

Distinct	50
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26.596

Minimum	1
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	15
median	27
Q3	39
95-th percentile	49
Maximum	50
Range	49
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	14.243654
Coefficient of variation (CV)	0.53555623
Kurtosis	-1.1301031
Mean	26.596
Median Absolute Deviation (MAD)	12
Skewness	-0.083965956
Sum	26596
Variance	202.88167
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	35	3.5%
42	30	3.0%
27	30	3.0%
49	29	2.9%
31	27	2.7%
22	27	2.7%
24	26	2.6%
9	25	2.5%
19	23	2.3%
50	23	2.3%
Other values (40)	725	72.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	13	1.3%
2	21	2.1%
3	19	1.9%
4	11	1.1%
5	23	2.3%
6	22	2.2%
7	11	1.1%
8	20	2.0%
9	25	2.5%
10	15	1.5%

Value	Count	Frequency (%)
50	23	2.3%
49	29	2.9%
48	19	1.9%
47	22	2.2%
46	22	2.2%
45	17	1.7%
44	21	2.1%
43	14	1.4%
42	30	3.0%
41	22	2.2%

preferred_category
Categorical

Distinct	5
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

Electronics	215
Sports	210
Home & Garden	206
Groceries	199
Clothing	170

Length

Max length	13
Median length	9
Mean length	9.454
Min length	6

Characters and Unicode

Total characters	9454
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Groceries
2nd row	Sports
3rd row	Clothing
4th row	Home & Garden
5th row	Electronics

Common Values

Value	Count	Frequency (%)
Electronics	215	21.5%
Sports	210	21.0%
Home & Garden	206	20.6%
Groceries	199	19.9%
Clothing	170	17.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
electronics	215	15.2%
sports	210	14.9%
home	206	14.6%
	206	14.6%
garden	206	14.6%
groceries	199	14.1%
clothing	170	12.0%

Most occurring characters

Value	Count	Frequency (%)
r	1029	10.9%
e	1025	10.8%
o	1000	10.6%
c	629	6.7%
s	624	6.6%
t	595	6.3%
n	591	6.3%
i	584	6.2%
	412	4.4%
G	405	4.3%
Other values (12)	2560	27.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9454	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	1029	10.9%
e	1025	10.8%
o	1000	10.6%
c	629	6.7%
s	624	6.6%
t	595	6.3%
n	591	6.3%
i	584	6.2%
	412	4.4%
G	405	4.3%
Other values (12)	2560	27.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9454	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	1029	10.9%
e	1025	10.8%
o	1000	10.6%
c	629	6.7%
s	624	6.6%
t	595	6.3%
n	591	6.3%
i	584	6.2%
	412	4.4%
G	405	4.3%
Other values (12)	2560	27.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9454	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	1029	10.9%
e	1025	10.8%
o	1000	10.6%
c	629	6.7%
s	624	6.6%
t	595	6.3%
n	591	6.3%
i	584	6.2%
	412	4.4%
G	405	4.3%
Other values (12)	2560	27.1%

last_purchase_amount
Real number (ℝ)

Distinct	994
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	492.34867

Minimum	10.4
Maximum	999.74
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	10.4
5-th percentile	45.0495
Q1	218.7625
median	491.595
Q3	747.17
95-th percentile	944.253
Maximum	999.74
Range	989.34
Interquartile range (IQR)	528.4075

Descriptive statistics

Standard deviation	295.74425
Coefficient of variation (CV)	0.60068051
Kurtosis	-1.2739791
Mean	492.34867
Median Absolute Deviation (MAD)	266.62
Skewness	0.017553616
Sum	492348.67
Variance	87464.663
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
559.73	2	0.2%
553.35	2	0.2%
66.6	2	0.2%
140.52	2	0.2%
937.86	2	0.2%
532.51	2	0.2%
758.44	1	0.1%
566.59	1	0.1%
760.27	1	0.1%
900.16	1	0.1%
Other values (984)	984	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10.4	1	0.1%
11.01	1	0.1%
11.29	1	0.1%
12.36	1	0.1%
12.45	1	0.1%
13.16	1	0.1%
13.46	1	0.1%
13.69	1	0.1%
14.52	1	0.1%
15.04	1	0.1%

Value	Count	Frequency (%)
999.74	1	0.1%
998.98	1	0.1%
998.51	1	0.1%
998.09	1	0.1%
997.24	1	0.1%
997.15	1	0.1%
994.1	1	0.1%
992.17	1	0.1%
991.93	1	0.1%
990.87	1	0.1%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	id	age	gender	income	spending_score	membership_years	purchase_frequency	preferred_category	last_purchase_amount
0	1	38	Female	99342	90	3	24	Groceries	113.53
1	2	21	Female	78852	60	2	42	Sports	41.93
2	3	60	Female	126573	30	2	28	Clothing	424.36
3	4	40	Other	47099	74	9	5	Home & Garden	991.93
4	5	65	Female	140621	21	3	25	Electronics	347.08
5	6	31	Other	57305	24	3	30	Home & Garden	86.85
6	7	19	Other	54319	68	5	43	Clothing	191.72
7	8	43	Male	108115	94	9	27	Groceries	734.56
8	9	53	Male	34424	29	6	7	Sports	951.71
9	10	55	Female	45839	55	7	2	Electronics	821.18

	id	age	gender	income	spending_score	membership_years	purchase_frequency	preferred_category	last_purchase_amount
990	991	21	Other	80264	41	4	26	Sports	458.93
991	992	53	Other	83578	97	5	50	Sports	917.08
992	993	22	Female	125479	57	8	27	Home & Garden	139.75
993	994	29	Female	64799	42	5	19	Electronics	967.26
994	995	60	Male	71923	25	2	40	Clothing	986.97
995	996	57	Male	112170	57	6	1	Clothing	313.64
996	997	23	Other	65337	76	10	23	Groceries	632.83
997	998	23	Male	113097	40	5	42	Sports	75.09
998	999	22	Female	113695	63	7	44	Electronics	505.16
999	1000	36	Female	90420	7	2	31	Groceries	669.26

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Missing values

Sample